UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'duDT07MZMZBmEUSDwg6OY3xZHW3F5LOxOXN7iJ9j9DU='
WHERE
key_id = '0b648c918fe3fe17bfa93ab2929836cc573ddc60f0ccef00994df14371f8647d'
AND (
token = 'duDT07MZMZBmEUSDwg6OY3xZHW3F5LOxOXN7iJ9j9DU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)