UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QCjSpgAIJikgtCq8da+qH4xPMh0V2gwzB7KF2LcJdo='
WHERE
key_id = '417d2c10122dccb6f12784804407fa206df4b734e94505d03a355d93146b0dc4'
AND (
token = '0QCjSpgAIJikgtCq8da+qH4xPMh0V2gwzB7KF2LcJdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)