UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3CA9x69lQCDMbENlL4l5jSgXOaYM8Mmv+i2Aeb+C6PA='
WHERE
key_id = '8fa18771a822423b1141ec7d601a7a101e57b558b09e91312de502db63a78fbf'
AND (
token = '3CA9x69lQCDMbENlL4l5jSgXOaYM8Mmv+i2Aeb+C6PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)