UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+ZsWQXEwDgH+cGgnim1hpzwH50He4RQbJwg2QxhRFQ='
WHERE
key_id = '9d2019e768d1e42d3609232a32812509aea66e37d9a96ec25c1710ff9f2eb995'
AND (
token = 'X+ZsWQXEwDgH+cGgnim1hpzwH50He4RQbJwg2QxhRFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)