UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ocisRp1yxCjYey9DQkPD4nFB6MVd9lFqjgtCGjNA68c='
WHERE
key_id = '4b99196940a4b86149280c2789a36ff5ace69ff101dbd40a82eca99a8888ee64'
AND (
token = 'ocisRp1yxCjYey9DQkPD4nFB6MVd9lFqjgtCGjNA68c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)