UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/D7YjK0oNjHomNuWIe6yIj7LO/QbXXj2MJtvHoq3lLw='
WHERE
key_id = '6874d2629d237912d955d8150f5cbe90248d62271249d94cd603ce2287f07175'
AND (
token = '/D7YjK0oNjHomNuWIe6yIj7LO/QbXXj2MJtvHoq3lLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)