UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BnN2tLOWIvCb43ow2X4ojOA7O3J+KAdnaj9V9w6k4Jo='
WHERE
key_id = '9c1b162d29cba3454c347ff26cf4aa97bd8ab176142f10a0e7d72de09a06c20f'
AND (
token = 'BnN2tLOWIvCb43ow2X4ojOA7O3J+KAdnaj9V9w6k4Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)