UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QS4GFxN45XD2WuLyA/XBtTRg0IbnKrOwGlceg/3MzZg='
WHERE
key_id = '20e63e9bccdb8dcb4faae12bc251924bd001165b0df230228279cb8e79e05cc2'
AND (
token = 'QS4GFxN45XD2WuLyA/XBtTRg0IbnKrOwGlceg/3MzZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)