UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EF54xYPF4WfaJe7O4K8YV5U2olttgw503A9NLgFt+NM='
WHERE
key_id = 'f9482aae7041aae80653485d23df946f7080c1c7940fe4fdad75412eff85ba1a'
AND (
token = 'EF54xYPF4WfaJe7O4K8YV5U2olttgw503A9NLgFt+NM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)