UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPyT1G+Ghd5iacei+EZR3PvESgGnqqImZRzTadeBmtY='
WHERE
key_id = 'c4beb6e0e293d812c2bbd4abdd9b90e8bc0add70cae33b49a6807b17c83dbe8c'
AND (
token = 'cPyT1G+Ghd5iacei+EZR3PvESgGnqqImZRzTadeBmtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)