UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Tns5au5bsJ+BIyOIEEqhkbGonG0nMYKczD7qTT26Y0='
WHERE
key_id = '29fefb95e1f87b1a6521565a34b33bedc9edd0141fdd40085c1a029dade52ed9'
AND (
token = '1Tns5au5bsJ+BIyOIEEqhkbGonG0nMYKczD7qTT26Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)