UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGHjAQhkgKNM9I7Kavw4YxoB26hogDg32vglFxrzOFA='
WHERE
key_id = '7dd3199a4515bd78ef928670bd178a7e434e64cf5ae01b56d8dda8215b14bc90'
AND (
token = 'sGHjAQhkgKNM9I7Kavw4YxoB26hogDg32vglFxrzOFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)