UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gmIQCvvFcCCywABdpFbAX0Nvd4pCdC5L6Jf/vJf+PI='
WHERE
key_id = '2165c59f3903f83e09e52f5f30762b47dc766a7ac51ae24052a7ffc477dfc3ca'
AND (
token = '4gmIQCvvFcCCywABdpFbAX0Nvd4pCdC5L6Jf/vJf+PI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)