UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CODjUOh029aMIV60Ad1A5JMdGEu3GMfpPI/X2PaDrIc=' 
WHERE 
  key_id = '53c88ebf4ebfcbc5d7b2c593ab25655a3d8549323d76f7abf45bb78f537578cc' 
  AND (
    token = 'CODjUOh029aMIV60Ad1A5JMdGEu3GMfpPI/X2PaDrIc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020