UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xr7P1d/kYK6GMsJqHUG67+Dne+CWB+zT/f0DDqivPVM='
WHERE
key_id = 'bdc2b0885664832cb37c5f3509c2364621d3a8e6169e248b9375f046e5687371'
AND (
token = 'Xr7P1d/kYK6GMsJqHUG67+Dne+CWB+zT/f0DDqivPVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)