UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oj8ES51J8bL+nTtb4gQ87U7pg6H9UkZZ/P/iyz9Z8cI='
WHERE
key_id = 'ebf0b36b7acafd1a122309e3cc273be14ff9f924233b579942070a67ab74c47f'
AND (
token = 'oj8ES51J8bL+nTtb4gQ87U7pg6H9UkZZ/P/iyz9Z8cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)