UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asREI5HbU2RzvU0icNERHPYa9tOtqXjQmqK/ptANeuo='
WHERE
key_id = '2e6631fd7d66fbff3da78c46365f5fd5815db27e3a48a1d3c4941b104c2b291b'
AND (
token = 'asREI5HbU2RzvU0icNERHPYa9tOtqXjQmqK/ptANeuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)