UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFQOoKSuF/E/HXRmkIlcs1e/V8jymfggXEnF0kbrJS0='
WHERE
key_id = 'e9790937080ccfe64721a00122c41a1c04a2e98f3d943970fb0a571d8f8100b6'
AND (
token = 'gFQOoKSuF/E/HXRmkIlcs1e/V8jymfggXEnF0kbrJS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)