UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7PK8epE4YCQO5O2/M71o9DWQpgSS+WjDhhmGu37a418='
WHERE
key_id = '6f4139f78695e095838c57b5ca6a6bf68ac4e74a6eb71378092d36dff03ded98'
AND (
token = '7PK8epE4YCQO5O2/M71o9DWQpgSS+WjDhhmGu37a418='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)