UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4p/iSDG9mZFVzMgqdBo9PvPQF0Vew3mrq938LpIUow='
WHERE
key_id = 'ddefb1781849f3b97e2d092fa88f287e2d92cd9bae004c0b6569004660cf3787'
AND (
token = 'C4p/iSDG9mZFVzMgqdBo9PvPQF0Vew3mrq938LpIUow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)