UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b/qdnulMLDDGk2wJ/HeC9SnmyTM4KHC8w6kSWiawMns='
WHERE
key_id = '49df690416638db60091df754f64dc459235118bf8e46190d075f03d43657cbf'
AND (
token = 'b/qdnulMLDDGk2wJ/HeC9SnmyTM4KHC8w6kSWiawMns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)