UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2tn8j4u4zbmbuEu/J651hqtNS23r1r829UwIz6Hw6k='
WHERE
key_id = 'e796a1ac5454395c281db2f36abbd31c1f0ccfb5f60badaa1010a537782f788a'
AND (
token = 'C2tn8j4u4zbmbuEu/J651hqtNS23r1r829UwIz6Hw6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)