UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZFVL5BWctFRMP2T0IdWrBktRYFuBC2QUjXDnY2Dq1fA=' 
WHERE 
  key_id = '598399b7c8e443869ff269cdd8739db5154f5518efa62fe5bc4891ce79fb0163' 
  AND (
    token = 'ZFVL5BWctFRMP2T0IdWrBktRYFuBC2QUjXDnY2Dq1fA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035