UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Be2d8aBO0Oeu2SagmBUSz4VFfv/THbJq8A3rxqbg5XA='
WHERE
key_id = 'b3bfe03c74499a8cc78cd7e93917e481806932d159abe0d991f343a9edfb8dcb'
AND (
token = 'Be2d8aBO0Oeu2SagmBUSz4VFfv/THbJq8A3rxqbg5XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)