UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWpCL68/RvEiG1fQrxi/+tSvow2DOhOHTc6m5vxx8jA='
WHERE
key_id = '371aa8472b112cda308c2017c954cdd549408f2bf064a46504c0e4aa5299503e'
AND (
token = 'XWpCL68/RvEiG1fQrxi/+tSvow2DOhOHTc6m5vxx8jA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)