UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDzlYXo818XhOmUiYJtesiLtbHkir7sj3ztlegiB5JU='
WHERE
key_id = '2a669710f61040246b017221b56cd55c8a0dbaac19e04cc42a3df7eee965b066'
AND (
token = 'XDzlYXo818XhOmUiYJtesiLtbHkir7sj3ztlegiB5JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)