UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SDHKt2XiOwmAF/mhRx43V7XyXJey9re/yLZGS6gClJ8='
WHERE
key_id = 'd46efb7542f69120e4757234c3434cbb8c8cd891223293bc99491e9de8a0dd33'
AND (
token = 'SDHKt2XiOwmAF/mhRx43V7XyXJey9re/yLZGS6gClJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)