UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wa5rAS7lKx1xW5hSDi+EyE6wBO+6rj19pZtpuSds2Zw='
WHERE
key_id = 'c028a73c13a14fa46be679fc79efeacd1d4a845395e9a628cd123f0b88f34491'
AND (
token = 'wa5rAS7lKx1xW5hSDi+EyE6wBO+6rj19pZtpuSds2Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)