UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e2fQzM+5pC3V6nz6anj/iLcih97X8HhM0cYKh8G7Yt4='
WHERE
key_id = 'b7e7dac0663aec2dcb0ea95db634bfb314e30df9ec52b6e98a15df1151741900'
AND (
token = 'e2fQzM+5pC3V6nz6anj/iLcih97X8HhM0cYKh8G7Yt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)