UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AQ5q1qzT705pGesM6fpE/zcZd/58qqI+YlsPawXlP8M=' 
WHERE 
  key_id = '6dd6e381d077a70b586f1d13a5a793668a22ad34f944ed8a908a2ee0988be8a3' 
  AND (
    token = 'AQ5q1qzT705pGesM6fpE/zcZd/58qqI+YlsPawXlP8M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040